Problem Note 49150: A "Failed to fetch SQL results" error occurs when SAS® In-Database runs the procedures DMREG, DMDB, or DMINE
 |  |  |  |  |
When you use SAS In-Database to run PROC DMREG, PROC DMDB, or PROC DMINE, the following errors might occur:
ERROR: Failed to fetch SQL results. ERROR: Begin messages from the DBMS. ERROR: Error code = -2130708362. ERROR: SQL state from the DBMS HY001. ERROR: Memory allocation error ERROR: End messages from the DBMS.
When those procedures run, permanent data tables are created in the database. After each procedure runs, these permanent data tables should be deleted automatically. However, they are not deleted. If another user ID runs the same code later, then the database does not allow the code to run due to permissions that are set on the table.
There is no workaround.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Windows Vista for x64 | 9.3_M1 | 9.3 TS1M1 | ||
| Windows Vista | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Professional x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Professional 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows XP Professional | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M1 | 9.3 TS1M1 | ||||
| Microsoft® Windows® for x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Linux | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Linux for x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.3_M1 | 9.4 | 9.3 TS1M1 | 9.4 TS1M0 | ||
A fix for this issue for SAS Enterprise Miner 12.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J33.html#49150
Permanent Tables should be deleted but are not during database clean up when running DMREG, DMDB, or DMINE.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Data Mining Data Management ==> Data Sources ==> External Databases ==> Teradata |
| Date Modified: | 2014-01-29 14:41:50 |
| Date Created: | 2013-02-13 16:26:15 |